CREATE EXTERNAL TABLE IF NOT EXISTS jms_ods.lq_new_sms_record(
id                                                 bigint                         COMMENT '',
version                                            Double                         COMMENT '',
createtime                                         String                         COMMENT '',
lastupdatetime                                     String                         COMMENT '',
status                                             String                         COMMENT '',
wxStatus                                           String                         COMMENT '',
operation                                          String                         COMMENT '',
billCode                                           String                         COMMENT '',
mobile                                             String                         COMMENT '',
content                                            String                         COMMENT '',
seqId                                              String                         COMMENT '',
smsCount                                           Double                         COMMENT '',
templateId                                         Double                         COMMENT '',
batchSeq                                           String                         COMMENT '',
orderId                                            Double                         COMMENT '',
sendDate                                           String                         COMMENT '',
type                                               String                         COMMENT '',
appUserId                                          String                         COMMENT '',
remark                                             String                         COMMENT '',
wxRemark                                           String                         COMMENT '',
goodsNumber                                        String                         COMMENT '',
expressCode                                        String                         COMMENT '',
templateName                                       String                         COMMENT '',
serviceSiteCode                                    String                         COMMENT ''
)
COMMENT ''
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/lq_new_sms_record'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
)